create table my_emp
(
    empno		int not null,
    update_ts   datetime not null,
    name		varchar(30) not null,
    duty		char(1) not null,
    age			smallint not null,
    address     varchar(200) not null,
    primary key(empno)
) engine=innodb;

begin;
insert into my_emp values(1,sysdate(),'职员1','1',20,'上海');
insert into my_emp values(2,sysdate(),'职员2','2',25,'北京');
insert into my_emp values(3,sysdate(),'职员3','3',40,'天津');
insert into my_emp values(4,sysdate(),'职员4','3',32,'黑龙江');
insert into my_emp values(5,sysdate(),'职员5','4',28,'新疆');
insert into my_emp values(6,sysdate(),'职员6','4',29,'湖北');
insert into my_emp values(7,sysdate(),'职员7','4',23,'广东');
insert into my_emp values(8,sysdate(),'职员8','5',47,'江苏');
insert into my_emp values(9,sysdate(),'职员9','5',41,'河南');
insert into my_emp values(10,sysdate(),'职员10','6',30,'四川');
commit;
